IF OBJECT_ID('ssf.dpnd_get_dependency_object') IS NOT NULL
	DROP FUNCTION ssf.dpnd_get_dependency_object
GO

CREATE FUNCTION ssf.dpnd_get_dependency_object (
	@dpnd_object_name NVARCHAR(256)
)
RETURNS TABLE
AS
	RETURN (
		SELECT dpnd_object_id
			, header_object_id
			, dependency_type
			, dpnd_object_name
			, object_type
			, change_type
		FROM ssf.dpnd_dependency_object WITH (NOLOCK)
		WHERE header_object_id = ssf.dpnd_get_header_object_id(@dpnd_object_name)
	)
GO
